package com.ledi.guns.common.persistence.dao;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.ledi.guns.common.persistence.model.HelpType;

/**
 * <p>
 * 帮助中心类型关系表 Mapper 接口
 * </p>
 *
 * @author zhongxp
 * @since 2018-08-13
 */
public interface HelpTypeMapper extends BaseMapper<HelpType> {

	@Select("select count(1) from t_help_type ht  left join t_help_center hc on hc.id=ht.help_id where ht.is_nomal=1 and  hc.title  like concat('%', #{title},'%')  ")
	Integer selectCountByTitleAndIsNomal(@Param("title") String title, @Param("isNomal") int isNomal);

}
